Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	1327457
Missing cells	263
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	151.9 MiB
Average record size in memory	120.0 B

Variable types

Numeric	15

Alerts

`issue_apm` is highly correlated with `structure_ratio` and 1 other fields	High correlation
`structure_ratio` is highly correlated with `issue_apm` and 1 other fields	High correlation
`land_ratio` is highly correlated with `t1_ratio`	High correlation
`t1_ratio` is highly correlated with `issue_apm` and 2 other fields	High correlation
`t2_ratio` is highly correlated with `t3_ratio` and 1 other fields	High correlation
`t3_ratio` is highly correlated with `t2_ratio`	High correlation
`defense_ratio` is highly correlated with `t2_ratio`	High correlation
`issue_apm` is highly correlated with `structure_ratio`	High correlation
`structure_ratio` is highly correlated with `issue_apm` and 2 other fields	High correlation
`land_ratio` is highly correlated with `structure_ratio` and 1 other fields	High correlation
`t1_ratio` is highly correlated with `structure_ratio` and 1 other fields	High correlation
`issue_apm` is highly correlated with `structure_ratio`	High correlation
`structure_ratio` is highly correlated with `issue_apm` and 1 other fields	High correlation
`land_ratio` is highly correlated with `t1_ratio`	High correlation
`t1_ratio` is highly correlated with `structure_ratio` and 1 other fields	High correlation
`game_id` is highly correlated with `player_id`	High correlation
`player_id` is highly correlated with `game_id`	High correlation
`issue_apm` is highly correlated with `structure_ratio` and 2 other fields	High correlation
`structure_ratio` is highly correlated with `issue_apm` and 2 other fields	High correlation
`land_ratio` is highly correlated with `structure_ratio` and 1 other fields	High correlation
`t1_ratio` is highly correlated with `issue_apm` and 2 other fields	High correlation
`t2_ratio` is highly correlated with `issue_apm`	High correlation
`t4_ratio` is highly skewed (γ1 = 523.9540876)	Skewed
`reclaim_ratio` has 184983 (13.9%) zeros	Zeros
`overcharge_ratio` has 1142248 (86.0%) zeros	Zeros
`transport_ratio` has 930667 (70.1%) zeros	Zeros
`air_ratio` has 179076 (13.5%) zeros	Zeros
`naval_ratio` has 1059757 (79.8%) zeros	Zeros
`t2_ratio` has 234982 (17.7%) zeros	Zeros
`t3_ratio` has 946491 (71.3%) zeros	Zeros
`t4_ratio` has 1266415 (95.4%) zeros	Zeros
`defense_ratio` has 227799 (17.2%) zeros	Zeros

Reproduction

Analysis started	2022-07-28 03:19:38.180085
Analysis finished	2022-07-28 03:21:40.886703
Duration	2 minutes and 2.71 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

game_id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	680759
Distinct (%)	51.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10542194.94

Minimum	4424784
Maximum	17181303
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	10.1 MiB

Quantile statistics

Minimum	4424784
5-th percentile	4841314
Q1	7230264
median	10527277
Q3	13746199
95-th percentile	16411896
Maximum	17181303
Range	12756519
Interquartile range (IQR)	6515935

Descriptive statistics

Standard deviation	3733881.713
Coefficient of variation (CV)	0.3541844688
Kurtosis	-1.231493651
Mean	10542194.94
Median Absolute Deviation (MAD)	3261289
Skewness	0.03161082887
Sum	1.399431046 × 10¹³
Variance	1.394187264 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000006	2	< 0.1%
5689138	2	< 0.1%
5687866	2	< 0.1%
5687874	2	< 0.1%
5687892	2	< 0.1%
5687916	2	< 0.1%
5687941	2	< 0.1%
5687948	2	< 0.1%
5687964	2	< 0.1%
5688007	2	< 0.1%
Other values (680749)	1327437	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
4424784	2	< 0.1%
4424786	2	< 0.1%
4424820	2	< 0.1%
4424834	2	< 0.1%
4424841	2	< 0.1%
4424872	2	< 0.1%
4424873	2	< 0.1%
4424896	2	< 0.1%
4424898	2	< 0.1%
4424922	2	< 0.1%

Value	Count	Frequency (%)
17181303	2	< 0.1%
17181252	2	< 0.1%
17181221	2	< 0.1%
17181204	2	< 0.1%
17181175	2	< 0.1%
17181141	2	< 0.1%
17181140	2	< 0.1%
17181050	2	< 0.1%
17181017	2	< 0.1%
17180986	2	< 0.1%

player_id
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	31058
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	176389.4346

Minimum	22
Maximum	446864
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	10.1 MiB

Quantile statistics

Minimum	22
5-th percentile	13043
Q1	69346
median	162869
Q3	271807
95-th percentile	390331
Maximum	446864
Range	446842
Interquartile range (IQR)	202461

Descriptive statistics

Standard deviation	123047.1068
Coefficient of variation (CV)	0.6975877387
Kurtosis	-0.9837531045
Mean	176389.4346
Median Absolute Deviation (MAD)	97682
Skewness	0.367418764
Sum	2.341493897 × 10¹¹
Variance	1.51405905 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
116558	18547	1.4%
14492	9303	0.7%
145245	7920	0.6%
21234	7812	0.6%
15955	7688	0.6%
65327	7286	0.5%
435	7083	0.5%
5147	6494	0.5%
118213	5941	0.4%
25438	5917	0.4%
Other values (31048)	1243466	93.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
22	117	< 0.1%
23	12	< 0.1%
24	324	< 0.1%
36	1	< 0.1%
45	1	< 0.1%
47	24	< 0.1%
55	16	< 0.1%
69	10	< 0.1%
72	26	< 0.1%
91	23	< 0.1%

Value	Count	Frequency (%)
446864	1	< 0.1%
446835	8	< 0.1%
446813	2	< 0.1%
446802	1	< 0.1%
446783	3	< 0.1%
446752	1	< 0.1%
446719	1	< 0.1%
446648	16	< 0.1%
446442	4	< 0.1%
446410	1	< 0.1%

issue_apm
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1080005
Distinct (%)	81.4%
Missing	263
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	34.49405492

Minimum	6.565920523 × 10^-6
Maximum	251.6129032
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	10.1 MiB

Quantile statistics

Minimum	6.565920523 × 10^-6
5-th percentile	12.86278874
Q1	21.53798826
median	30.79224755
Q3	44.37271653
95-th percentile	67.65534068
Maximum	251.6129032
Range	251.6128967
Interquartile range (IQR)	22.83472827

Descriptive statistics

Standard deviation	17.32399606
Coefficient of variation (CV)	0.5022313586
Kurtosis	1.273288671
Mean	34.49405492
Median Absolute Deviation (MAD)	10.73737392
Skewness	1.0266057
Sum	45780302.72
Variance	300.1208397
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30	1031	0.1%
12.24489796	600	< 0.1%
12	585	< 0.1%
10.90909091	580	< 0.1%
11.53846154	576	< 0.1%
11.32075472	557	< 0.1%
13.63636364	519	< 0.1%
11.76470588	506	< 0.1%
12.5	502	< 0.1%
11.11111111	499	< 0.1%
Other values (1079995)	1321239	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.565920523 × 10^-6	1	< 0.1%
1.369064283 × 10^-5	1	< 0.1%
0.03199658703	1	< 0.1%
0.0345323741	1	< 0.1%
0.04868549172	1	< 0.1%
0.05402485143	1	< 0.1%
0.06815084053	1	< 0.1%
0.08075370121	1	< 0.1%
0.08287292818	1	< 0.1%
0.08392782207	1	< 0.1%

Value	Count	Frequency (%)
251.6129032	1	< 0.1%
226.8115942	1	< 0.1%
216.4948454	1	< 0.1%
212.345679	1	< 0.1%
193.75	1	< 0.1%
192.8571429	1	< 0.1%
185.106383	1	< 0.1%
183.8709677	1	< 0.1%
182.9268293	1	< 0.1%
180.5471125	1	< 0.1%

reclaim_ratio
Real number (ℝ_≥0)

ZEROS

Distinct	157981
Distinct (%)	11.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.06184654418

Minimum	0
Maximum	1
Zeros	184983
Zeros (%)	13.9%
Negative	0
Negative (%)	0.0%
Memory size	10.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.006741573034
median	0.03121098627
Q3	0.08562197092
95-th percentile	0.2269523057
Maximum	1
Range	1
Interquartile range (IQR)	0.07888039789

Descriptive statistics

Standard deviation	0.08192279968
Coefficient of variation (CV)	1.324614023
Kurtosis	8.988952493
Mean	0.06184654418
Median Absolute Deviation (MAD)	0.02911383972
Skewness	2.491208745
Sum	82098.628
Variance	0.006711345108
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	184983	13.9%
0.07692307692	851	0.1%
0.04166666667	820	0.1%
0.03846153846	817	0.1%
0.06666666667	816	0.1%
0.07142857143	807	0.1%
0.04347826087	806	0.1%
0.04761904762	804	0.1%
0.05555555556	803	0.1%
0.05263157895	803	0.1%
Other values (157971)	1135147	85.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	184983	13.9%
0.0002288853285	1	< 0.1%
0.0002339181287	1	< 0.1%
0.0002440214739	1	< 0.1%
0.000246852629	1	< 0.1%
0.0002525890376	1	< 0.1%
0.0002600780234	1	< 0.1%
0.0002664535039	1	< 0.1%
0.0002671653754	1	< 0.1%
0.0002757099531	1	< 0.1%

Value	Count	Frequency (%)
1	48	< 0.1%
0.9375	1	< 0.1%
0.8974358974	1	< 0.1%
0.8928571429	1	< 0.1%
0.880952381	1	< 0.1%
0.8766756032	1	< 0.1%
0.875	2	< 0.1%
0.869047619	1	< 0.1%
0.8676470588	1	< 0.1%
0.8623481781	1	< 0.1%

overcharge_ratio
Real number (ℝ_≥0)

ZEROS

Distinct	21101
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.001053043863

Minimum	0
Maximum	0.1922043011
Zeros	1142248
Zeros (%)	86.0%
Negative	0
Negative (%)	0.0%
Memory size	10.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.007149240393
Maximum	0.1922043011
Range	0.1922043011
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.004015170533
Coefficient of variation (CV)	3.812918602
Kurtosis	87.90849788
Mean	0.001053043863
Median Absolute Deviation (MAD)	0
Skewness	7.188728344
Sum	1397.870447
Variance	1.612159441 × 10^-5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1142248	86.0%
0.005494505495	163	< 0.1%
0.005524861878	160	< 0.1%
0.006622516556	158	< 0.1%
0.00625	154	< 0.1%
0.007352941176	153	< 0.1%
0.005102040816	153	< 0.1%
0.0078125	152	< 0.1%
0.007142857143	151	< 0.1%
0.005917159763	151	< 0.1%
Other values (21091)	183814	13.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1142248	86.0%
0.0001393339836	1	< 0.1%
0.0001720578114	1	< 0.1%
0.0001836884644	1	< 0.1%
0.000192566917	1	< 0.1%
0.000202757502	1	< 0.1%
0.0002067397147	1	< 0.1%
0.0002106149958	1	< 0.1%
0.0002129925453	1	< 0.1%
0.0002158428664	1	< 0.1%

Value	Count	Frequency (%)
0.1922043011	1	< 0.1%
0.1592128801	1	< 0.1%
0.1444823663	1	< 0.1%
0.138671875	1	< 0.1%
0.1382113821	1	< 0.1%
0.1363636364	1	< 0.1%
0.1322751323	1	< 0.1%
0.1322674419	1	< 0.1%
0.1308411215	1	< 0.1%
0.1291028446	1	< 0.1%

transport_ratio
Real number (ℝ_≥0)

ZEROS

Distinct	37137
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.003734134572

Minimum	0
Maximum	0.3091603053
Zeros	930667
Zeros (%)	70.1%
Negative	0
Negative (%)	0.0%
Memory size	10.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.004021447721
95-th percentile	0.02019822461
Maximum	0.3091603053
Range	0.3091603053
Interquartile range (IQR)	0.004021447721

Descriptive statistics

Standard deviation	0.008136431788
Coefficient of variation (CV)	2.178933735
Kurtosis	25.86068011
Mean	0.003734134572
Median Absolute Deviation (MAD)	0
Skewness	3.693555262
Sum	4956.903076
Variance	6.620152224 × 10^-5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	930667	70.1%
0.01449275362	369	< 0.1%
0.01351351351	369	< 0.1%
0.01408450704	366	< 0.1%
0.01694915254	366	< 0.1%
0.0119047619	366	< 0.1%
0.009174311927	364	< 0.1%
0.01538461538	364	< 0.1%
0.01149425287	361	< 0.1%
0.008695652174	358	< 0.1%
Other values (37127)	393507	29.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	930667	70.1%
0.00019462826	1	< 0.1%
0.0002333177788	1	< 0.1%
0.0002497502498	1	< 0.1%
0.0002525252525	1	< 0.1%
0.0002530364372	1	< 0.1%
0.000253164557	1	< 0.1%
0.000256147541	1	< 0.1%
0.0002568053416	1	< 0.1%
0.0002643404705	1	< 0.1%

Value	Count	Frequency (%)
0.3091603053	1	< 0.1%
0.3047619048	1	< 0.1%
0.2273809524	1	< 0.1%
0.2197309417	1	< 0.1%
0.2192982456	1	< 0.1%
0.2057142857	1	< 0.1%
0.2043010753	1	< 0.1%
0.201754386	1	< 0.1%
0.1952662722	1	< 0.1%
0.1946902655	1	< 0.1%

structure_ratio
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	183210
Distinct (%)	13.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2215266485

Minimum	0
Maximum	1
Zeros	2489
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	10.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0.07661290323
Q1	0.1279826464
median	0.1812080537
Q3	0.2571428571
95-th percentile	0.4845196041
Maximum	1
Range	1
Interquartile range (IQR)	0.1291602107

Descriptive statistics

Standard deviation	0.1640505984
Coefficient of variation (CV)	0.7405456614
Kurtosis	10.51549392
Mean	0.2215266485
Median Absolute Deviation (MAD)	0.06111276542
Skewness	2.92910561
Sum	294067.1002
Variance	0.02691259884
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	30961	2.3%
0.5	3679	0.3%
0.25	3240	0.2%
0.3333333333	3221	0.2%
0.2	3006	0.2%
0.1666666667	2593	0.2%
0	2489	0.2%
0.1428571429	1975	0.1%
0.6666666667	1823	0.1%
0.125	1539	0.1%
Other values (183200)	1272931	95.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2489	0.2%
0.0009057971014	1	< 0.1%
0.001156069364	1	< 0.1%
0.0015625	1	< 0.1%
0.0016	1	< 0.1%
0.00185528757	1	< 0.1%
0.001941747573	1	< 0.1%
0.00205338809	1	< 0.1%
0.002087682672	1	< 0.1%
0.002183406114	1	< 0.1%

Value	Count	Frequency (%)
1	30961	2.3%
0.9936102236	1	< 0.1%
0.987012987	1	< 0.1%
0.9864864865	1	< 0.1%
0.9827586207	2	< 0.1%
0.9811320755	1	< 0.1%
0.9803921569	1	< 0.1%
0.9772727273	1	< 0.1%
0.9756097561	1	< 0.1%
0.9736842105	1	< 0.1%

air_ratio
Real number (ℝ_≥0)

ZEROS

Distinct	89535
Distinct (%)	6.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.03259337437

Minimum	0
Maximum	1
Zeros	179076
Zeros (%)	13.5%
Negative	0
Negative (%)	0.0%
Memory size	10.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.01123595506
median	0.02450980392
Q3	0.0431372549
95-th percentile	0.08722741433
Maximum	1
Range	1
Interquartile range (IQR)	0.03190129985

Descriptive statistics

Standard deviation	0.04459548684
Coefficient of variation (CV)	1.3682378
Kurtosis	222.3843749
Mean	0.03259337437
Median Absolute Deviation (MAD)	0.01527799449
Skewness	11.40241227
Sum	43266.30297
Variance	0.001988757447
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	179076	13.5%
0.03571428571	1565	0.1%
0.03225806452	1496	0.1%
0.03448275862	1481	0.1%
0.03703703704	1477	0.1%
0.03333333333	1474	0.1%
0.03846153846	1467	0.1%
0.0303030303	1461	0.1%
0.02857142857	1460	0.1%
0.04545454545	1455	0.1%
Other values (89525)	1135045	85.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	179076	13.5%
0.0002848191398	1	< 0.1%
0.0003117206983	1	< 0.1%
0.0003133813851	1	< 0.1%
0.0003235198965	1	< 0.1%
0.0003404834866	1	< 0.1%
0.000340947835	1	< 0.1%
0.0003427004798	1	< 0.1%
0.0003603603604	1	< 0.1%
0.0003653635367	1	< 0.1%

Value	Count	Frequency (%)
1	1273	0.1%
0.9590163934	1	< 0.1%
0.8888888889	2	< 0.1%
0.875	2	< 0.1%
0.8571428571	2	< 0.1%
0.8333333333	1	< 0.1%
0.8275862069	1	< 0.1%
0.8	1	< 0.1%
0.7916666667	1	< 0.1%
0.7727272727	1	< 0.1%

land_ratio
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	157701
Distinct (%)	11.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1473298496

Minimum	0
Maximum	1
Zeros	7531
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	10.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0.03773584906
Q1	0.07698961938
median	0.1151515152
Q3	0.1712062257
95-th percentile	0.3333333333
Maximum	1
Range	1
Interquartile range (IQR)	0.0942166063

Descriptive statistics

Standard deviation	0.1354591488
Coefficient of variation (CV)	0.9194277275
Kurtosis	20.12508459
Mean	0.1473298496
Median Absolute Deviation (MAD)	0.04423460971
Skewness	3.9215678
Sum	195574.0402
Variance	0.01834918101
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	17323	1.3%
0	7531	0.6%
0.3333333333	5008	0.4%
0.5	4927	0.4%
0.2	4355	0.3%
0.25	4341	0.3%
0.1666666667	4098	0.3%
0.1428571429	3771	0.3%
0.125	3071	0.2%
0.1111111111	2702	0.2%
Other values (157691)	1270330	95.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7531	0.6%
0.001094091904	1	< 0.1%
0.001098901099	1	< 0.1%
0.001131221719	1	< 0.1%
0.001222493888	1	< 0.1%
0.001255492781	1	< 0.1%
0.001338688086	1	< 0.1%
0.001342281879	1	< 0.1%
0.001427551749	1	< 0.1%
0.001453488372	1	< 0.1%

Value	Count	Frequency (%)
1	17323	1.3%
0.9772727273	1	< 0.1%
0.976744186	1	< 0.1%
0.9743589744	1	< 0.1%
0.96875	3	< 0.1%
0.9677419355	1	< 0.1%
0.9666666667	1	< 0.1%
0.9655172414	1	< 0.1%
0.962962963	2	< 0.1%
0.9615384615	1	< 0.1%

naval_ratio
Real number (ℝ_≥0)

ZEROS

Distinct	51401
Distinct (%)	3.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.006293813221

Minimum	0
Maximum	1
Zeros	1059757
Zeros (%)	79.8%
Negative	0
Negative (%)	0.0%
Memory size	10.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.04176904177
Maximum	1
Range	1
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.01691427038
Coefficient of variation (CV)	2.687443968
Kurtosis	67.91057647
Mean	0.006293813221
Median Absolute Deviation (MAD)	0
Skewness	4.670360223
Sum	8354.766418
Variance	0.0002860925424
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1059757	79.8%
0.03125	304	< 0.1%
0.04166666667	291	< 0.1%
0.0303030303	291	< 0.1%
0.03703703704	289	< 0.1%
0.03225806452	276	< 0.1%
0.02564102564	276	< 0.1%
0.0243902439	275	< 0.1%
0.04	274	< 0.1%
0.04545454545	274	< 0.1%
Other values (51391)	265150	20.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1059757	79.8%
0.0002570694087	1	< 0.1%
0.0002630194634	1	< 0.1%
0.0002704164413	1	< 0.1%
0.0002968239834	1	< 0.1%
0.0003070310101	1	< 0.1%
0.0003095975232	1	< 0.1%
0.000313283208	1	< 0.1%
0.0003135779241	1	< 0.1%
0.000320410125	1	< 0.1%

Value	Count	Frequency (%)
1	4	< 0.1%
0.95	1	< 0.1%
0.5	4	< 0.1%
0.451754386	1	< 0.1%
0.4444444444	1	< 0.1%
0.4405594406	1	< 0.1%
0.3828125	1	< 0.1%
0.375	1	< 0.1%
0.3636363636	1	< 0.1%
0.3571428571	1	< 0.1%

t1_ratio
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	188568
Distinct (%)	14.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2976308655

Minimum	0
Maximum	1
Zeros	2481
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	10.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0.1112099644
Q1	0.1822503962
median	0.2524752475
Q3	0.3520179372
95-th percentile	0.6666666667
Maximum	1
Range	1
Interquartile range (IQR)	0.169767541

Descriptive statistics

Standard deviation	0.182605301
Coefficient of variation (CV)	0.6135294493
Kurtosis	4.834715322
Mean	0.2976308655
Median Absolute Deviation (MAD)	0.08078151203
Skewness	2.023291706
Sum	395092.1758
Variance	0.03334469595
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	35068	2.6%
0.5	3206	0.2%
0.3333333333	3064	0.2%
0.25	2521	0.2%
0	2481	0.2%
0.6666666667	2185	0.2%
0.75	1894	0.1%
0.2	1759	0.1%
0.8	1583	0.1%
0.8333333333	1508	0.1%
Other values (188558)	1272188	95.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2481	0.2%
0.001811594203	1	< 0.1%
0.0022172949	1	< 0.1%
0.002506265664	1	< 0.1%
0.002617801047	1	< 0.1%
0.002680965147	1	< 0.1%
0.003205128205	1	< 0.1%
0.004175365344	1	< 0.1%
0.005882352941	1	< 0.1%
0.00625	1	< 0.1%

Value	Count	Frequency (%)
1	35068	2.6%
0.987012987	2	< 0.1%
0.9868421053	1	< 0.1%
0.9861111111	1	< 0.1%
0.9855072464	1	< 0.1%
0.9852941176	3	< 0.1%
0.9848484848	2	< 0.1%
0.9846153846	2	< 0.1%
0.9841269841	2	< 0.1%
0.9838709677	1	< 0.1%

t2_ratio
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	131833
Distinct (%)	9.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.04321170463

Minimum	0
Maximum	0.9776357827
Zeros	234982
Zeros (%)	17.7%
Negative	0
Negative (%)	0.0%
Memory size	10.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.004405286344
median	0.02578796562
Q3	0.06265356265
95-th percentile	0.1460674157
Maximum	0.9776357827
Range	0.9776357827
Interquartile range (IQR)	0.05824827631

Descriptive statistics

Standard deviation	0.05357911382
Coefficient of variation (CV)	1.23992132
Kurtosis	10.95193654
Mean	0.04321170463
Median Absolute Deviation (MAD)	0.02449430456
Skewness	2.504736442
Sum	57361.67979
Variance	0.002870721438
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	234982	17.7%
0.05882352941	840	0.1%
0.05263157895	822	0.1%
0.07692307692	810	0.1%
0.0625	810	0.1%
0.05555555556	801	0.1%
0.03846153846	799	0.1%
0.05	796	0.1%
0.04166666667	783	0.1%
0.06666666667	781	0.1%
Other values (131823)	1085233	81.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	234982	17.7%
0.0003310162198	1	< 0.1%
0.0003372681282	1	< 0.1%
0.0003571428571	1	< 0.1%
0.0003743916136	1	< 0.1%
0.0003765060241	1	< 0.1%
0.0003780718336	1	< 0.1%
0.0003838771593	1	< 0.1%
0.0004273504274	1	< 0.1%
0.0004366812227	1	< 0.1%

Value	Count	Frequency (%)
0.9776357827	1	< 0.1%
0.9069767442	1	< 0.1%
0.8888888889	1	< 0.1%
0.875	3	< 0.1%
0.8571428571	2	< 0.1%
0.8125	1	< 0.1%
0.8111111111	1	< 0.1%
0.8051282051	1	< 0.1%
0.8	1	< 0.1%
0.7777777778	2	< 0.1%

t3_ratio
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	76783
Distinct (%)	5.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.007015405283

Minimum	0
Maximum	1
Zeros	946491
Zeros (%)	71.3%
Negative	0
Negative (%)	0.0%
Memory size	10.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.002044989775
95-th percentile	0.04371584699
Maximum	1
Range	1
Interquartile range (IQR)	0.002044989775

Descriptive statistics

Standard deviation	0.02061846572
Coefficient of variation (CV)	2.939027025
Kurtosis	60.53709401
Mean	0.007015405283
Median Absolute Deviation (MAD)	0
Skewness	5.485198705
Sum	9312.648851
Variance	0.0004251211286
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	946491	71.3%
0.003984063745	189	< 0.1%
0.003115264798	183	< 0.1%
0.003424657534	183	< 0.1%
0.004016064257	183	< 0.1%
0.003355704698	182	< 0.1%
0.003448275862	181	< 0.1%
0.003215434084	180	< 0.1%
0.003134796238	179	< 0.1%
0.005050505051	178	< 0.1%
Other values (76773)	379328	28.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	946491	71.3%
0.0002158428664	1	< 0.1%
0.0002281542323	1	< 0.1%
0.0002576655501	1	< 0.1%
0.0002649708532	1	< 0.1%
0.0002713704206	1	< 0.1%
0.0002749518834	1	< 0.1%
0.0002804262479	1	< 0.1%
0.0002895193978	1	< 0.1%
0.0002942907593	1	< 0.1%

Value	Count	Frequency (%)
1	6	< 0.1%
0.6666666667	1	< 0.1%
0.6428571429	1	< 0.1%
0.5673758865	1	< 0.1%
0.5	3	< 0.1%
0.4753974262	1	< 0.1%
0.4560216509	1	< 0.1%
0.4460255152	1	< 0.1%
0.4361445783	1	< 0.1%
0.4182156134	1	< 0.1%

t4_ratio
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	10441
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.0001065681643

Minimum	0
Maximum	1
Zeros	1266415
Zeros (%)	95.4%
Negative	0
Negative (%)	0.0%
Memory size	10.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1
Range	1
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.001132214919
Coefficient of variation (CV)	10.624326
Kurtosis	458372.5156
Mean	0.0001065681643
Median Absolute Deviation (MAD)	0
Skewness	523.9540876
Sum	141.4646557
Variance	1.281910623 × 10^-6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1266415	95.4%
0.001976284585	61	< 0.1%
0.001912045889	60	< 0.1%
0.001805054152	59	< 0.1%
0.001795332136	59	< 0.1%
0.001897533207	58	< 0.1%
0.001550387597	56	< 0.1%
0.001610305958	55	< 0.1%
0.001579778831	55	< 0.1%
0.001543209877	54	< 0.1%
Other values (10431)	60525	4.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1266415	95.4%
0.0001275998469	1	< 0.1%
0.0001594642003	1	< 0.1%
0.0001687478907	1	< 0.1%
0.0001735809755	1	< 0.1%
0.0001750393839	1	< 0.1%
0.0001768033946	1	< 0.1%
0.0001783166904	1	< 0.1%
0.0001805054152	1	< 0.1%
0.0001815541031	1	< 0.1%

Value	Count	Frequency (%)
1	1	< 0.1%
0.08051628765	1	< 0.1%
0.0690316395	1	< 0.1%
0.06466302368	1	< 0.1%
0.06313993174	1	< 0.1%
0.0626566416	1	< 0.1%
0.06240713224	1	< 0.1%
0.06031933767	1	< 0.1%
0.06011854361	1	< 0.1%
0.05934718101	1	< 0.1%

defense_ratio
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	88884
Distinct (%)	6.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.02267242342

Minimum	0
Maximum	1
Zeros	227799
Zeros (%)	17.2%
Negative	0
Negative (%)	0.0%
Memory size	10.1 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.003636363636
median	0.0126459144
Q3	0.02941176471
95-th percentile	0.07987220447
Maximum	1
Range	1
Interquartile range (IQR)	0.02577540107

Descriptive statistics

Standard deviation	0.03261947666
Coefficient of variation (CV)	1.438729158
Kurtosis	115.0229925
Mean	0.02267242342
Median Absolute Deviation (MAD)	0.01100657013
Skewness	6.282074313
Sum	30096.66718
Variance	0.001064030257
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	227799	17.2%
0.02173913043	941	0.1%
0.02325581395	930	0.1%
0.025	930	0.1%
0.02127659574	927	0.1%
0.02083333333	922	0.1%
0.01639344262	919	0.1%
0.01818181818	917	0.1%
0.02564102564	916	0.1%
0.0303030303	915	0.1%
Other values (88874)	1091341	82.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	227799	17.2%
0.0002686727566	1	< 0.1%
0.000279798545	1	< 0.1%
0.0002810567735	1	< 0.1%
0.0003008423586	1	< 0.1%
0.0003088326127	1	< 0.1%
0.0003261578604	1	< 0.1%
0.0003571428571	1	< 0.1%
0.0003632401017	1	< 0.1%
0.000366568915	1	< 0.1%

Value	Count	Frequency (%)
1	108	< 0.1%
0.987012987	1	< 0.1%
0.9827586207	1	< 0.1%
0.9803921569	1	< 0.1%
0.9772727273	1	< 0.1%
0.9736842105	1	< 0.1%
0.972972973	1	< 0.1%
0.9714285714	1	< 0.1%
0.9701492537	1	< 0.1%
0.9677419355	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	game_id	player_id	issue_apm	reclaim_ratio	transport_ratio	structure_ratio	air_ratio	land_ratio	naval_ratio	t1_ratio	t2_ratio	t3_ratio	t4_ratio	defense_ratio
0	10000006	304205	33.300943	0.022657	0.000000	0.141092	0.017508	0.078270	0.000000	0.122554	0.065911	0.019567	0.001030	0.008239
1	10000006	258198	46.119403	0.029873	0.004481	0.109037	0.011949	0.047050	0.000000	0.103062	0.048544	0.006721	0.000000	0.052278
2	10000034	26737	20.049689	0.100372	0.000000	0.278810	0.014870	0.167286	0.000000	0.364312	0.074349	0.000000	0.000000	0.018587
3	10000034	41066	19.076623	0.003831	0.000000	0.203065	0.000000	0.130268	0.000000	0.283525	0.019157	0.000000	0.000000	0.015326
4	10000035	226514	43.486778	0.010135	0.011824	0.222973	0.025338	0.150338	0.000000	0.285473	0.065878	0.000000	0.000000	0.010135
5	10000035	55124	34.175334	0.082609	0.002174	0.256522	0.028261	0.110870	0.000000	0.341304	0.000000	0.000000	0.000000	0.013043
6	10000046	203172	63.618875	0.022412	0.000000	0.098186	0.033084	0.074707	0.000000	0.175027	0.004269	0.000000	0.000000	0.001067
7	10000046	33632	54.502583	0.006180	0.022250	0.233622	0.064277	0.195303	0.000000	0.404203	0.016069	0.004944	0.000000	0.037083
8	10000067	89175	17.137616	0.000000	0.000000	0.405199	0.090214	0.114679	0.168196	0.431193	0.238532	0.045872	0.004587	0.125382
9	10000067	278581	10.594796	0.007519	0.020050	0.298246	0.125313	0.085213	0.052632	0.250627	0.157895	0.050125	0.010025	0.025063

Last rows

	game_id	player_id	issue_apm	reclaim_ratio	overcharge_ratio	transport_ratio	structure_ratio	air_ratio	land_ratio	naval_ratio	t1_ratio	t2_ratio	t3_ratio	defense_ratio
1327447	9999811	231084	20.993702	0.090000	0.003333	0.000000	0.323333	0.033333	0.133333	0.000000	0.393333	0.050000	0.000000	0.013333
1327448	9999811	145245	23.261278	0.148485	0.000000	0.051515	0.348485	0.024242	0.203030	0.000000	0.512121	0.012121	0.000000	0.093939
1327449	9999832	33632	67.370008	0.107383	0.002237	0.002983	0.121551	0.053691	0.091723	0.002983	0.196122	0.035794	0.000000	0.013423
1327450	9999832	203172	77.860676	0.169897	0.000000	0.005168	0.083979	0.020026	0.055556	0.016796	0.133075	0.009690	0.000000	0.004522
1327451	9999855	256946	33.405114	0.000000	0.000000	0.000000	0.149073	0.026591	0.091056	0.000000	0.127317	0.053989	0.016922	0.003223
1327452	9999855	55124	36.533644	0.101396	0.000000	0.000000	0.127112	0.029390	0.080088	0.000000	0.085966	0.116826	0.010287	0.024247
1327453	9999918	89175	14.588206	0.000000	0.000000	0.000000	0.306329	0.037975	0.278481	0.000000	0.382278	0.134177	0.032911	0.030380
1327454	9999918	278581	13.730061	0.032172	0.000000	0.000000	0.184987	0.000000	0.096515	0.000000	0.163539	0.088472	0.000000	0.016086
1327455	9999977	203172	70.355623	0.201405	0.000000	0.000000	0.037471	0.000000	0.058548	0.000000	0.086651	0.000000	0.000000	0.000000
1327456	9999977	33632	89.305765	0.062557	0.002760	0.000000	0.034959	0.005520	0.063477	0.000000	0.087397	0.000000	0.000000	0.000920

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows